#!/bin/bash

#赵宗尧
sqoop import \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/teach \
--query "select *, '2024-08-21' as dt from class_studying_student_count WHERE 1=1 and \$CONDITIONS" \
--hcatalog-database oe_ods \
--hcatalog-table t_class_studying_student_count \
--fields-terminated-by '\t' \
-m 1
#赵宗尧
sqoop import \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/teach \
--query "select *, '2024-08-21' as dt from course_table_upload_detail WHERE 1=1 and \$CONDITIONS" \
--fields-terminated-by '\t' \
--hcatalog-database oe_ods \
--hcatalog-table t_course_table_upload_detail \
-m 1
#赵宗尧
sqoop import \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/teach \
--query "select *, '2024-08-21' as dt from student_leave_apply WHERE 1=1 and \$CONDITIONS" \
--fields-terminated-by '\t' \
--hcatalog-database oe_ods \
--hcatalog-table t_student_leave_apply \
-m 1
#赵宗尧
sqoop import \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/teach \
--query "select *, '2024-08-21' as dt from tbh_class_time_table WHERE 1=1 and \$CONDITIONS" \
--fields-terminated-by '\t' \
--hcatalog-database oe_ods \
--hcatalog-table t_class_time_table \
-m 1
#赵宗尧
sqoop import \
--username root \
--password 123456 \
--connect jdbc:mysql://hadoop01:3306/teach \
--query "select *, '2024-08-21' as dt from tbh_student_signin_record WHERE 1=1 and \$CONDITIONS" \
--fields-terminated-by '\t' \
--hcatalog-database oe_ods \
--hcatalog-table t_student_signin_record \
-m 1
